IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTInsurances_Retrieve')
	BEGIN
		PRINT 'Dropping Procedure spTInsurances_Retrieve'
		DROP  Procedure  spTInsurances_Retrieve
	END

GO

PRINT 'Creating Procedure spTInsurances_Retrieve'
GO
CREATE Procedure dbo.spTInsurances_Retrieve
	(
	  @TInsurances_ID  bigint
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 8/23/2007   Initial version created
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Create the required new record
	SELECT  *
	FROM    TInsurances
	WHERE   TInsurances.TInsurances_ID = @TInsurances_ID

	-- Return to calling method
	RETURN 

GO
